from pymysql import Connection

conn = Connection(
    host="localhost",
    port=3306,
    user='root',
    password='wenxiao829@',
    autocommit=True
)
print(conn.get_server_info())

cursor = conn.cursor()
conn.select_db('test')
cursor.execute("insert into 'student' values( 1,'温晓健', 31,)")
conn.commit()

conn.close()
